Defining Microsoft Azure SQL Managed Instance database settings
Set the following for the Microsoft Azure SQL Managed Instance database(s) that you are using as a source:
- From the Object Explorer in the Microsoft Azure SQL Managed Instance Management Studio, right click the database and select Properties. In the Options tab, set the Recovery model to Bulk logged or Full. In this mode, the transaction Log is more durable and truncation occurs less frequently.
- Ensure that there is a full database backup for each Microsoft Azure SQL Managed Instance database that you are using as a source.
- When creating a connection string, it is possible to use any parameter supported by Microsoft Azure SQL Managed Instance. The Microsoft Azure SQL Managed Instance system administrator must ensure that the Microsoft Azure SQL Managed Instance instance is configured correctly so that the proper authentication credentials are accepted.